How to Schedule a Query
- Start by clicking the scheduler (clock) icon located at the bottom of the query editor, to the left of the “Run” button
- A dialog will prompt you to set a refresh schedule and an execution tier. Please note that scheduled queries can only be run on medium and large query engines, which will require credits.
- The dialog will display an estimated monthly credit consumption for this query scheduling, along with a monthly quota. These values will adjust based on the frequency and execution tier you select.
- Save the schedule
- Your query will execute once to start the schedule, and then will execute according to the schedule you set.
Query Scheduling Limitations
- Query scheduling is currently not available for queries with parameters.
- The query schedule is removed when the queries are archived or when the ownership changes (e.g., when a query is migrated).
- There are no notifications available for scheduled query failures as of now. Rest assured, these failures do not result in any charges to your account.
Adjusting or Cancelling a Query Schedule
If you need to modify or cancel a query schedule, click on the scheduler icon to open the scheduling dialog. Make changes as needed or click “Stop” to cancel the schedule.